package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.annotation.DataSource;
import com.ruoyi.common.enums.DataSourceType;
import com.ruoyi.system.domain.OtherBlocketRecord;
import com.ruoyi.system.domain.OtherManualHostRecord;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;
import java.util.List;

@DataSource(value = DataSourceType.SLAVE)
public interface OtherManualHostRecordMapper extends BaseMapper<OtherManualHostRecord> {

    @Select("select wxid ,displayName, SUM(count) as totalvalue from ManualHostRecord where roomID=  #{roomId}  and roundDate BETWEEN #{startDate} AND #{endDate}   group by wxid,displayName")
    public List<HashMap> getManualHostRecord(@Param("roomId") String roomID, @Param("startDate") String startDate, @Param("endDate")String endDate, @Param("startTime")String startTime, @Param("endTime")String endTime);


}
